# MySQL-Front Dump 2.4
#
# Host: localhost   Database: 503roomdata
#--------------------------------------------------------
# Server version 3.23.40


#
# Table structure for table 'shop_admin'
#

CREATE TABLE `shop_admin` (
  `aid` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  `pwd` varchar(40) NOT NULL default '',
  `level` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`aid`)
) TYPE=MyISAM;



#
# Dumping data for table 'shop_admin'
#
INSERT INTO shop_admin VALUES("1", "admin", "21232F297A57A5A743894A0E4A801FC3", "1");
INSERT INTO shop_admin VALUES("8", "aa", "4124BC0A9335C27F086F24BA207A4912", "0");
INSERT INTO shop_admin VALUES("7", "qq", "D41D8CD98F00B204E9800998ECF8427E", "1");


#
# Table structure for table 'shop_catalog'
#

CREATE TABLE `shop_catalog` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `parentid` int(10) unsigned NOT NULL default '0',
  `title` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;



#
# Dumping data for table 'shop_catalog'
#
INSERT INTO shop_catalog VALUES("1", "0", "");
INSERT INTO shop_catalog VALUES("2", "0", "Ʒ");
INSERT INTO shop_catalog VALUES("59", "0", "洢");
INSERT INTO shop_catalog VALUES("4", "0", "");
INSERT INTO shop_catalog VALUES("31", "3", "ֻ");
INSERT INTO shop_catalog VALUES("32", "4", "MP3");
INSERT INTO shop_catalog VALUES("33", "4", "");
INSERT INTO shop_catalog VALUES("38", "2", "Ʒ");
INSERT INTO shop_catalog VALUES("35", "4", "");
INSERT INTO shop_catalog VALUES("36", "3", "绰");
INSERT INTO shop_catalog VALUES("37", "3", "Խ");
INSERT INTO shop_catalog VALUES("39", "2", "");
INSERT INTO shop_catalog VALUES("40", "2", "");
INSERT INTO shop_catalog VALUES("41", "1", "");
INSERT INTO shop_catalog VALUES("42", "1", "POP");
INSERT INTO shop_catalog VALUES("43", "1", "");
INSERT INTO shop_catalog VALUES("44", "1", "");
INSERT INTO shop_catalog VALUES("45", "0", "");
INSERT INTO shop_catalog VALUES("46", "0", "鼮");
INSERT INTO shop_catalog VALUES("48", "46", "Ƽ");
INSERT INTO shop_catalog VALUES("49", "46", "");
INSERT INTO shop_catalog VALUES("50", "46", "ϵͳ");
INSERT INTO shop_catalog VALUES("51", "45", "̨");
INSERT INTO shop_catalog VALUES("53", "45", "ŷ");
INSERT INTO shop_catalog VALUES("54", "45", "");
INSERT INTO shop_catalog VALUES("55", "45", "ϲ");
INSERT INTO shop_catalog VALUES("56", "4", "");
INSERT INTO shop_catalog VALUES("57", "4", "");
INSERT INTO shop_catalog VALUES("58", "4", "ҵ");
INSERT INTO shop_catalog VALUES("60", "59", "USB");
INSERT INTO shop_catalog VALUES("61", "59", "Ӳ");
INSERT INTO shop_catalog VALUES("62", "59", "");
INSERT INTO shop_catalog VALUES("63", "0", "");
INSERT INTO shop_catalog VALUES("64", "63", "");
INSERT INTO shop_catalog VALUES("65", "63", "ϲ");
INSERT INTO shop_catalog VALUES("66", "63", "");


#
# Table structure for table 'shop_gbook_info'
#

CREATE TABLE `shop_gbook_info` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `product_id` int(10) unsigned NOT NULL default '0',
  `content` text NOT NULL,
  `author` varchar(100) NOT NULL default '',
  `level` tinyint(4) NOT NULL default '0',
  `date_time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;



#
# Dumping data for table 'shop_gbook_info'
#
INSERT INTO shop_gbook_info VALUES("10", "52", "hjkfghk", "fhkfh", "4", "2003-07-11 02:41:28");
INSERT INTO shop_gbook_info VALUES("9", "55", "hjkhjk", "hjkg", "1", "2003-07-11 02:41:13");
INSERT INTO shop_gbook_info VALUES("8", "59", "jkljk", "kjl", "4", "2003-07-11 02:40:55");
INSERT INTO shop_gbook_info VALUES("11", "53", "ghjghj", "ghj", "3", "2003-07-11 02:41:46");
INSERT INTO shop_gbook_info VALUES("12", "57", "ghjfghj", "fgjhfghj", "3", "2003-07-11 02:42:01");
INSERT INTO shop_gbook_info VALUES("13", "60", "dyjdj", "fgjfgh", "2", "2003-07-11 02:42:19");
INSERT INTO shop_gbook_info VALUES("14", "56", "gjdfgdf", "fdghfd", "2", "2003-07-11 02:43:05");
INSERT INTO shop_gbook_info VALUES("15", "58", "hfjgh", "hgjgf", "4", "2003-07-11 02:43:59");
INSERT INTO shop_gbook_info VALUES("16", "54", "ghjghj", "ghjgh", "3", "2003-07-11 02:44:26");
INSERT INTO shop_gbook_info VALUES("17", "58", "ghjgh", "hgjg", "2", "2003-07-11 02:45:41");


#
# Table structure for table 'shop_member_favorite'
#

CREATE TABLE `shop_member_favorite` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `MName` varchar(20) NOT NULL default '',
  `Pid` int(10) unsigned NOT NULL default '0',
  `date_time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;



#
# Dumping data for table 'shop_member_favorite'
#


#
# Table structure for table 'shop_member_info'
#

CREATE TABLE `shop_member_info` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `account` varchar(20) NOT NULL default '',
  `pwd` varchar(50) NOT NULL default '',
  `name` varchar(20) NOT NULL default '',
  `age` tinyint(4) NOT NULL default '0',
  `sex` tinyint(4) NOT NULL default '0',
  `address` varchar(255) NOT NULL default '',
  `tel` varchar(100) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `log_times` int(11) NOT NULL default '0',
  `date_time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;



#
# Dumping data for table 'shop_member_info'
#
INSERT INTO shop_member_info VALUES("18", "leobasic", "07CDC8109C2E07FC33962305D73F2CB2", "", "24", "1", "", "133333333333333", "rr@rr.com", "13", "2002-12-11 11:09:25");
INSERT INTO shop_member_info VALUES("19", "basic", "099B3B060154898840F0EBDFB46EC78F", "˧1", "1", "2", "1", "1", "1fdgk@d.com", "25", "2003-07-04 16:47:00");
INSERT INTO shop_member_info VALUES("23", "jimy", "07CDC8109C2E07FC33962305D73F2CB2", "ש", "28", "1", "㶫ʡж·12305", "13333333", "fuck@21cn.com", "9", "2003-07-10 21:22:17");
INSERT INTO shop_member_info VALUES("24", "q", "7694F4A66316E53C8CDD9D9954BD611D", "q", "44", "2", "qfgd", "456456", "q@sefd.com", "4", "2003-07-10 22:56:19");


#
# Table structure for table 'shop_news_imgs'
#

CREATE TABLE `shop_news_imgs` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `info_id` int(10) unsigned NOT NULL default '0',
  `img_name` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;



#
# Dumping data for table 'shop_news_imgs'
#
INSERT INTO shop_news_imgs VALUES("1", "2", "1035232067730.jpg");
INSERT INTO shop_news_imgs VALUES("2", "3", "1035235151310.jpg");
INSERT INTO shop_news_imgs VALUES("5", "13", "1035476634150.jpg");
INSERT INTO shop_news_imgs VALUES("6", "13", "1035476634150.jpg");
INSERT INTO shop_news_imgs VALUES("7", "14", "1035481502480.jpg");
INSERT INTO shop_news_imgs VALUES("8", "14", "1035481502480.jpg");
INSERT INTO shop_news_imgs VALUES("9", "14", "1035481502480.jpg");
INSERT INTO shop_news_imgs VALUES("10", "14", "1035481502480.jpg");
INSERT INTO shop_news_imgs VALUES("11", "14", "1035481502480.jpg");
INSERT INTO shop_news_imgs VALUES("12", "14", "1035481502480.jpg");
INSERT INTO shop_news_imgs VALUES("13", "14", "1035481502480.jpg");
INSERT INTO shop_news_imgs VALUES("14", "14", "1035481502480.jpg");
INSERT INTO shop_news_imgs VALUES("32", "29", "1035568450580.jpg");
INSERT INTO shop_news_imgs VALUES("25", "18", "1035564626390.jpg");
INSERT INTO shop_news_imgs VALUES("27", "20", "1035566301950.jpg");
INSERT INTO shop_news_imgs VALUES("31", "28", "1035568441290.jpg");
INSERT INTO shop_news_imgs VALUES("30", "22", "1035566737340.jpg");


#
# Table structure for table 'shop_news_info'
#

CREATE TABLE `shop_news_info` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `type_id` int(10) unsigned NOT NULL default '0',
  `topic` varchar(255) NOT NULL default '',
  `original_content` text NOT NULL,
  `content` text NOT NULL,
  `content_type` tinyint(4) NOT NULL default '0',
  `pagination` varchar(14) NOT NULL default '',
  `keywords` varchar(50) NOT NULL default '',
  `click` int(11) NOT NULL default '0',
  `source` varchar(200) NOT NULL default '',
  `date_time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;



#
# Dumping data for table 'shop_news_info'
#
INSERT INTO shop_news_info VALUES("1078", "9", "", "hgjgh", "hgjgh", "0", "", "ghjg", "4", "ghj", "2003-07-04 23:25:57");
INSERT INTO shop_news_info VALUES("1081", "9", "ۣ", "ۣۣۣ", "ۣۣۣ", "0", "", "fghfgh", "4", "̳Ѷ", "2003-07-05 00:37:50");
INSERT INTO shop_news_info VALUES("1082", "9", "hhhhhhhhhhhhhh", "hhhhhhhhhhhh", "hhhhhhhhhhhh", "0", "", "hhh", "0", "hhhh", "2003-07-05 02:42:52");


#
# Table structure for table 'shop_news_type'
#

CREATE TABLE `shop_news_type` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;



#
# Dumping data for table 'shop_news_type'
#
INSERT INTO shop_news_type VALUES("9", "̳Ѷ");


#
# Table structure for table 'shop_orders_main'
#

CREATE TABLE `shop_orders_main` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(20) NOT NULL default '',
  `product_id` int(11) NOT NULL default '0',
  `r_info_id` int(11) NOT NULL default '0',
  `price` float unsigned NOT NULL default '0',
  `quantity` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;



#
# Dumping data for table 'shop_orders_main'
#
INSERT INTO shop_orders_main VALUES("31", "basic", "43", "16", "4554", "1");
INSERT INTO shop_orders_main VALUES("36", "leobasic", "51", "19", "644", "1");
INSERT INTO shop_orders_main VALUES("35", "leobasic", "48", "19", "54645", "1");
INSERT INTO shop_orders_main VALUES("30", "basic", "45", "16", "200", "6");
INSERT INTO shop_orders_main VALUES("29", "basic", "46", "16", "100", "1");
INSERT INTO shop_orders_main VALUES("28", "basic", "47", "16", "4444", "18");
INSERT INTO shop_orders_main VALUES("32", "basic", "44", "16", "5334", "2");
INSERT INTO shop_orders_main VALUES("33", "leobasic", "45", "17", "200", "1");
INSERT INTO shop_orders_main VALUES("34", "basic", "51", "18", "644", "18");
INSERT INTO shop_orders_main VALUES("37", "jimy", "49", "20", "465", "1");
INSERT INTO shop_orders_main VALUES("38", "jimy", "51", "20", "644", "1");
INSERT INTO shop_orders_main VALUES("39", "jimy", "50", "20", "444", "1");
INSERT INTO shop_orders_main VALUES("40", "jimy", "50", "21", "444", "1");
INSERT INTO shop_orders_main VALUES("41", "jimy", "49", "21", "465", "1");
INSERT INTO shop_orders_main VALUES("42", "q", "55", "23", "9.55", "17");
INSERT INTO shop_orders_main VALUES("43", "q", "57", "23", "9.5", "7");
INSERT INTO shop_orders_main VALUES("44", "q", "60", "24", "13", "14");


#
# Table structure for table 'shop_orders_r_info'
#

CREATE TABLE `shop_orders_r_info` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `r_name` varchar(20) NOT NULL default '',
  `r_address` varchar(200) NOT NULL default '',
  `r_tel` varchar(100) NOT NULL default '',
  `note` text NOT NULL,
  `status` tinyint(4) NOT NULL default '0',
  `date_time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;



#
# Dumping data for table 'shop_orders_r_info'
#
INSERT INTO shop_orders_r_info VALUES("16", "˧1", "1", "1", "", "0", "2003-07-06 01:27:09");
INSERT INTO shop_orders_r_info VALUES("17", "", "", "133333333333333", "", "1", "2003-07-07 08:14:53");
INSERT INTO shop_orders_r_info VALUES("18", "˧1", "1", "4444444", "dddddddddddddddd", "1", "2003-07-07 23:39:16");
INSERT INTO shop_orders_r_info VALUES("19", "", "", "999", "ͻǰȵ绰ϵ", "0", "2003-07-09 23:31:19");
INSERT INTO shop_orders_r_info VALUES("20", "leo102", "㶫ʡж·12305", "13333333", "㣡", "0", "2003-07-10 21:27:30");
INSERT INTO shop_orders_r_info VALUES("21", "ש", "㶫ʡж·12305", "13333333", "", "0", "2003-07-10 21:40:58");
INSERT INTO shop_orders_r_info VALUES("22", "q", "qfgd", "456456", "jk", "0", "2003-07-10 22:57:23");
INSERT INTO shop_orders_r_info VALUES("23", "q", "qfgd", "456456", "i", "0", "2003-07-10 23:03:17");
INSERT INTO shop_orders_r_info VALUES("24", "q", "qfgd", "456456", "ppppppppppppp", "0", "2003-07-10 23:13:14");


#
# Table structure for table 'shop_product_info'
#

CREATE TABLE `shop_product_info` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `catalog_id` int(10) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `keywords` varchar(100) NOT NULL default '',
  `img_path` varchar(200) NOT NULL default '',
  `price` float unsigned NOT NULL default '0',
  `absence` tinyint(4) NOT NULL default '0',
  `show_out` tinyint(4) NOT NULL default '0',
  `importance_show` tinyint(3) unsigned NOT NULL default '0',
  `click` int(11) NOT NULL default '0',
  `purchase_num` int(11) NOT NULL default '0',
  `date_time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;



#
# Dumping data for table 'shop_product_info'
#
INSERT INTO shop_product_info VALUES("52", "51", "EEG Twins2003ר", "EEG&nbsp;Twins2003ר", "Twins", "upload_img/1057845973300.jpg", "16", "0", "1", "0", "2", "0", "2003-07-10 22:06:48");
INSERT INTO shop_product_info VALUES("53", "51", "Դϲƪ ٻʺ20", "Դϲƪ&nbsp;ٻʺ20", "Դϲ", "upload_img/1057846154560.jpg", "89", "0", "1", "0", "2", "0", "2003-07-10 22:09:15");
INSERT INTO shop_product_info VALUES("54", "51", "йȫ ־5", "йȫ&nbsp;־5", "־,", "upload_img/1057846227610.jpg", "25", "0", "1", "0", "2", "3", "2003-07-10 22:10:29");
INSERT INTO shop_product_info VALUES("55", "51", "ż 鲽", "ż&nbsp;鲽", "鲽", "upload_img/1057846378270.jpg", "9.55", "0", "1", "0", "22", "0", "2003-07-10 22:12:59");
INSERT INTO shop_product_info VALUES("56", "55", "촽Ů", "λŮΪ޻Ц֮ϲ磡λŮһλӢܼңһλϴ㰮ңҰ˭˭ʷ׳ʣЦŹɹ", "촽Ů,", "upload_img/1057846715730.jpg", "93", "0", "1", "1", "3", "0", "2003-07-10 22:18:36");
INSERT INTO shop_product_info VALUES("57", "39", "ɫ̥3", "ҽѧרҺרҵֱ༭ʱµѪ֮δ˸ֺУ׸ΰͿɰĵСʹΰͺŹɹ", "ɫ̥", "upload_img/1057846772360.jpg", "9.5", "0", "1", "1", "10", "0", "2003-07-10 22:19:35");
INSERT INTO shop_product_info VALUES("58", "41", "й´ȫ", "ջޡ&nbsp;ƬĿǰʱһͳ¶ϵƬڶҵ̨Ƭ˴ʷ֪ʶŹɹ", "", "upload_img/1057846858870.jpg", "92", "0", "1", "0", "7", "5", "2003-07-10 22:20:59");
INSERT INTO shop_product_info VALUES("59", "62", "", "", "", "upload_img/1057846974760.jpg", "10", "0", "1", "0", "2", "0", "2003-07-10 22:22:56");
INSERT INTO shop_product_info VALUES("60", "49", "ݺĺDVD-9", "ݺĺDVD-9", "ݺĺ", "upload_img/1057847024410.jpg", "13.9", "0", "1", "0", "4", "1", "2003-07-10 22:23:45");
